package com.gopay.common.domain.pg;

import java.util.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;
import javax.persistence.Transient;

/**
 * 
 * @PgGenQueryTransDtl.java
 * @author GongZhong
 * @2013-1-8 下午03:19:53 www.gopay.com.cn Inc.All rights reserved.
 */
@Entity
@Table(name = "PG_GEN_QUERY_TRANS_DTL")
public class PgGenQueryTransDtl implements java.io.Serializable {

    /**
     * 
     */
    private static final long serialVersionUID = 1L;
    private int transDtlSq;
    private String merId;
    private String merOrderId;
    private String merTxnCd;
    private Date merTxnTm;
    private String userEmail;
    private String userAcct;
    private String queryMerOrderId;
    private Date queryMerTxnTm;
    private String transType;
    private Date timeBegin;
    private Date timeEnd;
    private String queryOrderStatus;
    private int resaultSetPageLines;
    private int pageNum;
    private int pageSize;
    private String gatewayVersion;
    private String charset;
    private String language;
    private String signType;
    private String rspCode;
    private String transLaunchIp;
    private String sysRemark;
    private Date createdTs;
    private Date lastUpdTs;
    private String lastUpdTrancode;
    private String merRemark3;
    private String merRemark1;
    private String merRemark2;
    private String merRemark4;
    private String merRemark5;

    private String merAccount;
    private String tranType;

    
    //商户健全增加字段  zhangzg 20150513
    
    private String merURL;//后台返回Url
    private String bankCode;//银行类型
    private String acctType;//银行卡类型
    private String phone;//银行绑定手机
    private String certType;//证件类型
    private String certNo;//证件号
    private String acctName;//持卡人姓名
    private String acctNum;//卡号
    private String acctValty;//信用卡有效期
    private String acctCvv;//cvv2码
    
    private String orderId;
    
    
  




    @Id
    @SequenceGenerator(name = "PgGenQueryTransDtlSequence", sequenceName = "PG_GEN_ORDER_TRANS_DTL_SEQ")
    @GeneratedValue(generator = "PgGenQueryTransDtlSequence", strategy = GenerationType.SEQUENCE)
    @Column(name = "TRANS_DTL_SQ", unique = true, nullable = false, precision = 22, scale = 0)
    public int getTransDtlSq() {
        return this.transDtlSq;
    }

    public void setTransDtlSq(int transDtlSq) {
        this.transDtlSq = transDtlSq;
    }

    @Column(name = "MER_ID", nullable = false, length = 10)
    public String getMerId() {
        return this.merId;
    }

    public void setMerId(String merId) {
        this.merId = merId;
    }

    @Column(name = "MER_ORDER_ID", nullable = false)
    public String getMerOrderId() {
        return this.merOrderId;
    }

    public void setMerOrderId(String merOrderId) {
        this.merOrderId = merOrderId;
    }

    @Column(name = "MER_TXN_CD", nullable = false, length = 10)
    public String getMerTxnCd() {
        return this.merTxnCd;
    }

    public void setMerTxnCd(String merTxnCd) {
        this.merTxnCd = merTxnCd;
    }

    @Column(name = "MER_TXN_TM", nullable = false)
    public Date getMerTxnTm() {
        return this.merTxnTm;
    }

    public void setMerTxnTm(Date merTxnTm) {
        this.merTxnTm = merTxnTm;
    }

    @Column(name = "USER_EMAIL", length = 30)
    public String getUserEmail() {
        return this.userEmail;
    }

    public void setUserEmail(String userEmail) {
        this.userEmail = userEmail;
    }

    @Column(name = "USER_ACCT", length = 19)
    public String getUserAcct() {
        return this.userAcct;
    }

    public void setUserAcct(String userAcct) {
        this.userAcct = userAcct;
    }

    @Column(name = "QUERY_MER_ORDER_ID")
    public String getQueryMerOrderId() {
        return this.queryMerOrderId;
    }

    public void setQueryMerOrderId(String queryMerOrderId) {
        this.queryMerOrderId = queryMerOrderId;
    }

    @Column(name = "QUERY_MER_TXN_TM")
    public Date getQueryMerTxnTm() {
        return this.queryMerTxnTm;
    }

    public void setQueryMerTxnTm(Date queryMerTxnTm) {
        this.queryMerTxnTm = queryMerTxnTm;
    }

    @Column(name = "TRANS_TYPE", length = 1)
    public String getTransType() {
        return this.transType;
    }

    public void setTransType(String transType) {
        this.transType = transType;
    }

    @Column(name = "TIME_BEGIN")
    public Date getTimeBegin() {
        return this.timeBegin;
    }

    public void setTimeBegin(Date timeBegin) {
        this.timeBegin = timeBegin;
    }

    @Column(name = "TIME_END")
    public Date getTimeEnd() {
        return this.timeEnd;
    }

    public void setTimeEnd(Date timeEnd) {
        this.timeEnd = timeEnd;
    }

    @Column(name = "QUERY_ORDER_STATUS", length = 2)
    public String getQueryOrderStatus() {
        return this.queryOrderStatus;
    }

    public void setQueryOrderStatus(String queryOrderStatus) {
        this.queryOrderStatus = queryOrderStatus;
    }

    @Column(name = "RESAULT_SET_PAGE_LINES", precision = 22, scale = 0)
    public int getResaultSetPageLines() {
        return this.resaultSetPageLines;
    }

    public void setResaultSetPageLines(int resaultSetPageLines) {
        this.resaultSetPageLines = resaultSetPageLines;
    }

    @Column(name = "PAGE_NUM", precision = 22, scale = 0)
    public int getPageNum() {
        return this.pageNum;
    }

    public void setPageNum(int pageNum) {
        this.pageNum = pageNum;
    }

    @Column(name = "GATEWAY_VERSION", nullable = false, length = 5)
    public String getGatewayVersion() {
        return this.gatewayVersion;
    }

    public void setGatewayVersion(String gatewayVersion) {
        this.gatewayVersion = gatewayVersion;
    }

    @Column(name = "CHARSET", length = 1)
    public String getCharset() {
        return this.charset;
    }

    public void setCharset(String charset) {
        this.charset = charset;
    }

    @Column(name = "LANGUAGE", length = 1)
    public String getLanguage() {
        return this.language;
    }

    public void setLanguage(String language) {
        this.language = language;
    }

    @Column(name = "SIGN_TYPE", length = 1)
    public String getSignType() {
        return this.signType;
    }

    public void setSignType(String signType) {
        this.signType = signType;
    }

    @Column(name = "RSP_CODE", nullable = false, length = 4)
    public String getRspCode() {
        return this.rspCode;
    }

    public void setRspCode(String rspCode) {
        this.rspCode = rspCode;
    }

    @Column(name = "TRANS_LAUNCH_IP", nullable = false, length = 50)
    public String getTransLaunchIp() {
        return this.transLaunchIp;
    }

    public void setTransLaunchIp(String transLaunchIp) {
        this.transLaunchIp = transLaunchIp;
    }

    @Column(name = "SYS_REMARK", length = 200)
    public String getSysRemark() {
        return this.sysRemark;
    }

    public void setSysRemark(String sysRemark) {
        this.sysRemark = sysRemark;
    }

    @Column(name = "CREATED_TS", nullable = false)
    public Date getCreatedTs() {
        return this.createdTs;
    }

    public void setCreatedTs(Date createdTs) {
        this.createdTs = createdTs;
    }

    @Column(name = "LAST_UPD_TS", nullable = false)
    public Date getLastUpdTs() {
        return this.lastUpdTs;
    }

    public void setLastUpdTs(Date lastUpdTs) {
        this.lastUpdTs = lastUpdTs;
    }

    @Column(name = "LAST_UPD_TRANCODE", length = 6)
    public String getLastUpdTrancode() {
        return this.lastUpdTrancode;
    }

    public void setLastUpdTrancode(String lastUpdTrancode) {
        this.lastUpdTrancode = lastUpdTrancode;
    }

    @Column(name = "MER_REMARK3", length = 500)
    public String getMerRemark3() {
        return this.merRemark3;
    }

    public void setMerRemark3(String merRemark3) {
        this.merRemark3 = merRemark3;
    }

    @Column(name = "MER_REMARK1", length = 500)
    public String getMerRemark1() {
        return this.merRemark1;
    }

    public void setMerRemark1(String merRemark1) {
        this.merRemark1 = merRemark1;
    }

    @Column(name = "MER_REMARK2", length = 500)
    public String getMerRemark2() {
        return this.merRemark2;
    }

    public void setMerRemark2(String merRemark2) {
        this.merRemark2 = merRemark2;
    }

    @Column(name = "MER_REMARK4", length = 500)
    public String getMerRemark4() {
        return this.merRemark4;
    }

    public void setMerRemark4(String merRemark4) {
        this.merRemark4 = merRemark4;
    }

    @Column(name = "MER_REMARK5", length = 500)
    public String getMerRemark5() {
        return this.merRemark5;
    }

    public void setMerRemark5(String merRemark5) {
        this.merRemark5 = merRemark5;
    }


    @Transient
	public int getPageSize() {
		return pageSize;
	}

	public void setPageSize(int pageSize) {
		this.pageSize = pageSize;
	}
	
	@Transient
	public String getMerAccount() {
		return merAccount;
	}

	public void setMerAccount(String merAccount) {
		this.merAccount = merAccount;
	}

	@Transient
	public String getTranType() {
		return tranType;
	}

	public void setTranType(String tranType) {
		this.tranType = tranType;
	}


    @Column(name = "mer_URL", length = 500)
	public String getMerURL() {
		return merURL;
	}

	public void setMerURL(String merURL) {
		this.merURL = merURL;
	}

	@Column(name = "bank_code",length = 10)
	public String getBankCode() {
		return bankCode;
	}

	public void setBankCode(String bankCode) {
		this.bankCode = bankCode;
	}
	
	@Column(name = "acc_type",length = 1)
	public String getAcctType() {
		return acctType;
	}

	public void setAcctType(String acctType) {
		this.acctType = acctType;
	}

	@Column(name = "phone",length = 11)
	public String getPhone() {
		return phone;
	}

	
	public void setPhone(String phone) {
		this.phone = phone;
	}

	@Column(name = "cert_type",length = 1)
	public String getCertType() {
		return certType;
	}

	public void setCertType(String certType) {
		this.certType = certType;
	}

	
	@Column(name = "cert_no",length = 18)
	public String getCertNo() {
		return certNo;
	}

	public void setCertNo(String certNo) {
		this.certNo = certNo;
	}

	@Column(name = "acc_name",length = 100)
	public String getAcctName() {
		return acctName;
	}

	public void setAcctName(String acctName) {
		this.acctName = acctName;
	}

	@Column(name = "acc_num",length = 30)
	public String getAcctNum() {
		return acctNum;
	}

	public void setAcctNum(String acctNum) {
		this.acctNum = acctNum;
	}

	
	@Column(name = "acct_Valty", length = 30)
	public String getAcctValty() {
		return acctValty;
	}

	public void setAcctValty(String acctValty) {
		this.acctValty = acctValty;
	}

	@Column(name = "acct_Cvv",  length = 30)
	public String getAcctCvv() {
		return acctCvv;
	}

	public void setAcctCvv(String acctCvv) {
		this.acctCvv = acctCvv;
	}

	@Column(name = "orderId",  length = 14)
	 public String getOrderId() {
			return orderId;
		}
	
	public void setOrderId(String orderId) {
		this.orderId = orderId;
	}

	public PgGenQueryTransDtl() {
    }
	

}
